home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vtripsgrps.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
45 lines
CREATE OR REPLACE VIEW VTRIPSGRPS AS
SELECT 'WKD' subgroup,
TRIPS.ROUTEID, TRIPS.RUNID, TRIPS.ID,
TRIPS.DEP_TIME, TRIPS.DIRECTION1,
TRIPS.DIRECTION2, TRIPS.MILEAGE,
TRIPS.CONFIG_NUM, day.num, DAY.DESCR
FROM
TRIPS TRIPS,
RUNS RUNS,
DAYOFWEEK DAY
WHERE
( TRIPS.RUNID=RUNS.ID ) AND
( TRIPS.ROUTEID=RUNS.ROUTEID ) AND
( RUNS.DAY=DAY.NUM ) AND RUNS.day IN (0, 2, 3, 4, 5, 6, 9)
UNION
SELECT 'WKE' subgroup,
TRIPS.ROUTEID, TRIPS.RUNID, TRIPS.ID,
TRIPS.DEP_TIME, TRIPS.DIRECTION1,
TRIPS.DIRECTION2, TRIPS.MILEAGE,
TRIPS.CONFIG_NUM, day.num, DAY.DESCR
FROM
TRIPS TRIPS,
RUNS RUNS,
DAYOFWEEK DAY
WHERE
( TRIPS.RUNID=RUNS.ID ) AND
( TRIPS.ROUTEID=RUNS.ROUTEID ) AND
( RUNS.DAY=DAY.NUM ) AND
RUNS.day IN (0, 1, 7, 8)
UNION
SELECT 'SCH' subgroup,
TRIPS.ROUTEID, TRIPS.RUNID, TRIPS.ID,
TRIPS.DEP_TIME, TRIPS.DIRECTION1,
TRIPS.DIRECTION2, TRIPS.MILEAGE,
TRIPS.CONFIG_NUM, day.num, DAY.DESCR
FROM
TRIPS TRIPS,
RUNS RUNS,
DAYOFWEEK DAY
WHERE
( TRIPS.RUNID=RUNS.ID ) AND
( TRIPS.ROUTEID=RUNS.ROUTEID ) AND
( RUNS.DAY=DAY.NUM ) AND
TO_CHAR(TRIPS.RUNID, '99999999') LIKE '%6_'